﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
namespace DataAccess.Content
{
    public class ContentDAL
    {
        private SQLDataAccess db;
        public ContentDAL()
        {
            db = new SQLDataAccess();
        }
        public DataTable getContentbyCatandLangID(int CatID, int LangID)
        {
            string query = "select * from [Content] ct join [LangContent] lct on ct.ContentID=lct.ContentID";
            query+=" where ct.ContentCID='"+CatID+"' and lct.LangID='"+LangID+"' and Publish=1";
            return db.exeSelect(query);
        }
    }
}
